Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	150000
Missing cells	1123500
Missing cells (%)	35.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	100.7 MiB
Average record size in memory	704.0 B

Variable types

DateTime	2
Text	4
Categorical	9
Numeric	6

Alerts

`Cancelled Rides by Customer` has constant value "1.0"	Constant
`Cancelled Rides by Driver` has constant value "1.0"	Constant
`Incomplete Rides` has constant value "1.0"	Constant
`Booking Status` is highly overall correlated with `Customer Rating` and 4 other fields	High correlation
`Customer Rating` is highly overall correlated with `Booking Status`	High correlation
`Driver Cancellation Reason` is highly overall correlated with `Booking Status`	High correlation
`Driver Ratings` is highly overall correlated with `Booking Status`	High correlation
`Incomplete Rides Reason` is highly overall correlated with `Booking Status`	High correlation
`Reason for cancelling by Customer` is highly overall correlated with `Booking Status`	High correlation
`Avg VTAT` has 10500 (7.0%) missing values	Missing
`Avg CTAT` has 48000 (32.0%) missing values	Missing
`Cancelled Rides by Customer` has 139500 (93.0%) missing values	Missing
`Reason for cancelling by Customer` has 139500 (93.0%) missing values	Missing
`Cancelled Rides by Driver` has 123000 (82.0%) missing values	Missing
`Driver Cancellation Reason` has 123000 (82.0%) missing values	Missing
`Incomplete Rides` has 141000 (94.0%) missing values	Missing
`Incomplete Rides Reason` has 141000 (94.0%) missing values	Missing
`Booking Value` has 48000 (32.0%) missing values	Missing
`Ride Distance` has 48000 (32.0%) missing values	Missing
`Driver Ratings` has 57000 (38.0%) missing values	Missing
`Customer Rating` has 57000 (38.0%) missing values	Missing
`Payment Method` has 48000 (32.0%) missing values	Missing

Reproduction

Analysis started	2025-08-30 11:27:45.661032
Analysis finished	2025-08-30 11:28:04.408630
Duration	18.75 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Date
Date

Distinct	365
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2024-01-01 00:00:00
Maximum	2024-12-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Time
Date

Distinct	62910
Distinct (%)	41.9%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-08-30 00:00:00
Maximum	2025-08-30 23:59:59
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Booking ID
Text

Distinct	148767
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1800000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	147543 ?
Unique (%)	98.4%

Sample

1st row	"CNR5884300"
2nd row	"CNR1326809"
3rd row	"CNR8494506"
4th row	"CNR8906825"
5th row	"CNR1950162"

Value	Count	Frequency (%)
cnr6337479	3	< 0.1%
cnr3648267	3	< 0.1%
cnr9603232	3	< 0.1%
cnr5292943	3	< 0.1%
cnr7585544	3	< 0.1%
cnr7199036	3	< 0.1%
cnr7642097	3	< 0.1%
cnr2726142	3	< 0.1%
cnr7908610	3	< 0.1%
cnr2869280	2	< 0.1%
Other values (148757)	149971	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
N	150000	8.3%
R	150000	8.3%
9	107075	5.9%
5	106822	5.9%
4	106770	5.9%
7	106760	5.9%
6	106752	5.9%
8	106627	5.9%
Other values (4)	409194	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
N	150000	8.3%
R	150000	8.3%
9	107075	5.9%
5	106822	5.9%
4	106770	5.9%
7	106760	5.9%
6	106752	5.9%
8	106627	5.9%
Other values (4)	409194	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
N	150000	8.3%
R	150000	8.3%
9	107075	5.9%
5	106822	5.9%
4	106770	5.9%
7	106760	5.9%
6	106752	5.9%
8	106627	5.9%
Other values (4)	409194	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
N	150000	8.3%
R	150000	8.3%
9	107075	5.9%
5	106822	5.9%
4	106770	5.9%
7	106760	5.9%
6	106752	5.9%
8	106627	5.9%
Other values (4)	409194	22.7%

Booking Status
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Completed	93000
Cancelled by Driver	27000
No Driver Found	10500
Cancelled by Customer	10500
Incomplete	9000

Length

Max length	21
Median length	9
Mean length	12.12
Min length	9

Characters and Unicode

Total characters	1818000
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Driver Found
2nd row	Incomplete
3rd row	Completed
4th row	Completed
5th row	Completed

Common Values

Value	Count	Frequency (%)
Completed	93000	62.0%
Cancelled by Driver	27000	18.0%
No Driver Found	10500	7.0%
Cancelled by Customer	10500	7.0%
Incomplete	9000	6.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
completed	93000	37.8%
cancelled	37500	15.2%
by	37500	15.2%
driver	37500	15.2%
no	10500	4.3%
found	10500	4.3%
customer	10500	4.3%
incomplete	9000	3.7%

Most occurring characters

Value	Count	Frequency (%)
e	327000	18.0%
l	177000	9.7%
C	141000	7.8%
d	141000	7.8%
o	133500	7.3%
t	112500	6.2%
m	112500	6.2%
p	102000	5.6%
	96000	5.3%
r	85500	4.7%
Other values (13)	390000	21.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1818000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	327000	18.0%
l	177000	9.7%
C	141000	7.8%
d	141000	7.8%
o	133500	7.3%
t	112500	6.2%
m	112500	6.2%
p	102000	5.6%
	96000	5.3%
r	85500	4.7%
Other values (13)	390000	21.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1818000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	327000	18.0%
l	177000	9.7%
C	141000	7.8%
d	141000	7.8%
o	133500	7.3%
t	112500	6.2%
m	112500	6.2%
p	102000	5.6%
	96000	5.3%
r	85500	4.7%
Other values (13)	390000	21.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1818000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	327000	18.0%
l	177000	9.7%
C	141000	7.8%
d	141000	7.8%
o	133500	7.3%
t	112500	6.2%
m	112500	6.2%
p	102000	5.6%
	96000	5.3%
r	85500	4.7%
Other values (13)	390000	21.5%

Customer ID
Text

Distinct	148788
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1800000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	147582 ?
Unique (%)	98.4%

Sample

1st row	"CID1982111"
2nd row	"CID4604802"
3rd row	"CID9202816"
4th row	"CID2610914"
5th row	"CID9933542"

Value	Count	Frequency (%)
cid8727691	3	< 0.1%
cid4523979	3	< 0.1%
cid6715450	3	< 0.1%
cid7828101	3	< 0.1%
cid6468528	3	< 0.1%
cid5481002	3	< 0.1%
cid4977850	2	< 0.1%
cid7088244	2	< 0.1%
cid7294800	2	< 0.1%
cid2877369	2	< 0.1%
Other values (148778)	149974	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
I	150000	8.3%
D	150000	8.3%
4	107135	6.0%
1	107018	5.9%
6	107016	5.9%
9	106654	5.9%
7	106632	5.9%
5	106484	5.9%
Other values (4)	409061	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
I	150000	8.3%
D	150000	8.3%
4	107135	6.0%
1	107018	5.9%
6	107016	5.9%
9	106654	5.9%
7	106632	5.9%
5	106484	5.9%
Other values (4)	409061	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
I	150000	8.3%
D	150000	8.3%
4	107135	6.0%
1	107018	5.9%
6	107016	5.9%
9	106654	5.9%
7	106632	5.9%
5	106484	5.9%
Other values (4)	409061	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1800000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
"	300000	16.7%
C	150000	8.3%
I	150000	8.3%
D	150000	8.3%
4	107135	6.0%
1	107018	5.9%
6	107016	5.9%
9	106654	5.9%
7	106632	5.9%
5	106484	5.9%
Other values (4)	409061	22.7%

Vehicle Type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 MiB

Auto	37419
Go Mini	29806
Go Sedan	27141
Bike	22517
Premier Sedan	18111
Other values (2)	15006

Length

Max length	13
Median length	8
Mean length	6.5659
Min length	4

Characters and Unicode

Total characters	984885
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	eBike
2nd row	Go Sedan
3rd row	Auto
4th row	Premier Sedan
5th row	Bike

Common Values

Value	Count	Frequency (%)
Auto	37419	24.9%
Go Mini	29806	19.9%
Go Sedan	27141	18.1%
Bike	22517	15.0%
Premier Sedan	18111	12.1%
eBike	10557	7.0%
Uber XL	4449	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
go	56947	24.8%
sedan	45252	19.7%
auto	37419	16.3%
mini	29806	13.0%
bike	22517	9.8%
premier	18111	7.9%
ebike	10557	4.6%
uber	4449	1.9%
xl	4449	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	129554	13.2%
i	110797	11.2%
o	94366	9.6%
	79507	8.1%
n	75058	7.6%
G	56947	5.8%
a	45252	4.6%
d	45252	4.6%
S	45252	4.6%
r	40671	4.1%
Other values (12)	262229	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	984885	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	129554	13.2%
i	110797	11.2%
o	94366	9.6%
	79507	8.1%
n	75058	7.6%
G	56947	5.8%
a	45252	4.6%
d	45252	4.6%
S	45252	4.6%
r	40671	4.1%
Other values (12)	262229	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	984885	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	129554	13.2%
i	110797	11.2%
o	94366	9.6%
	79507	8.1%
n	75058	7.6%
G	56947	5.8%
a	45252	4.6%
d	45252	4.6%
S	45252	4.6%
r	40671	4.1%
Other values (12)	262229	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	984885	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	129554	13.2%
i	110797	11.2%
o	94366	9.6%
	79507	8.1%
n	75058	7.6%
G	56947	5.8%
a	45252	4.6%
d	45252	4.6%
S	45252	4.6%
r	40671	4.1%
Other values (12)	262229	26.6%

Pickup Location
Text

Distinct	176
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Length

Max length	25
Median length	19
Mean length	11.505627
Min length	3

Characters and Unicode

Total characters	1725844
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Palam Vihar
2nd row	Shastri Nagar
3rd row	Khandsa
4th row	Central Secretariat
5th row	Ghitorni Village

Value	Count	Frequency (%)
nagar	14525	5.2%
vihar	8410	3.0%
chowk	6860	2.5%
park	5246	1.9%
sector	5031	1.8%
gurgaon	5016	1.8%
road	4244	1.5%
noida	4209	1.5%
city	3460	1.2%
garden	3408	1.2%
Other values (214)	217828	78.3%

Most occurring characters

Value	Count	Frequency (%)
a	277598	16.1%
r	128582	7.5%
	128237	7.4%
i	109699	6.4%
h	89268	5.2%
n	74783	4.3%
e	72093	4.2%
o	68791	4.0%
t	56145	3.3%
u	53591	3.1%
Other values (48)	667057	38.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1725844	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	277598	16.1%
r	128582	7.5%
	128237	7.4%
i	109699	6.4%
h	89268	5.2%
n	74783	4.3%
e	72093	4.2%
o	68791	4.0%
t	56145	3.3%
u	53591	3.1%
Other values (48)	667057	38.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1725844	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	277598	16.1%
r	128582	7.5%
	128237	7.4%
i	109699	6.4%
h	89268	5.2%
n	74783	4.3%
e	72093	4.2%
o	68791	4.0%
t	56145	3.3%
u	53591	3.1%
Other values (48)	667057	38.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1725844	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	277598	16.1%
r	128582	7.5%
	128237	7.4%
i	109699	6.4%
h	89268	5.2%
n	74783	4.3%
e	72093	4.2%
o	68791	4.0%
t	56145	3.3%
u	53591	3.1%
Other values (48)	667057	38.7%

Drop Location
Text

Distinct	176
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.7 MiB

Length

Max length	25
Median length	20
Mean length	11.511813
Min length	3

Characters and Unicode

Total characters	1726772
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jhilmil
2nd row	Gurgaon Sector 56
3rd row	Malviya Nagar
4th row	Inderlok
5th row	Khan Market

Value	Count	Frequency (%)
nagar	14533	5.2%
vihar	8538	3.1%
chowk	6656	2.4%
sector	5148	1.8%
gurgaon	5084	1.8%
park	5002	1.8%
noida	4315	1.5%
road	4130	1.5%
gate	3481	1.2%
place	3458	1.2%
Other values (214)	218245	78.3%

Most occurring characters

Value	Count	Frequency (%)
a	277071	16.0%
r	128702	7.5%
	128590	7.4%
i	109858	6.4%
h	89698	5.2%
n	74820	4.3%
e	72505	4.2%
o	69018	4.0%
t	56302	3.3%
u	53474	3.1%
Other values (48)	666734	38.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1726772	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	277071	16.0%
r	128702	7.5%
	128590	7.4%
i	109858	6.4%
h	89698	5.2%
n	74820	4.3%
e	72505	4.2%
o	69018	4.0%
t	56302	3.3%
u	53474	3.1%
Other values (48)	666734	38.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1726772	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	277071	16.0%
r	128702	7.5%
	128590	7.4%
i	109858	6.4%
h	89698	5.2%
n	74820	4.3%
e	72505	4.2%
o	69018	4.0%
t	56302	3.3%
u	53474	3.1%
Other values (48)	666734	38.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1726772	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	277071	16.0%
r	128702	7.5%
	128590	7.4%
i	109858	6.4%
h	89698	5.2%
n	74820	4.3%
e	72505	4.2%
o	69018	4.0%
t	56302	3.3%
u	53474	3.1%
Other values (48)	666734	38.6%

Avg VTAT
Real number (ℝ)

Missing

Distinct	181
Distinct (%)	0.1%
Missing	10500
Missing (%)	7.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.456352

Minimum	2
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2
5-th percentile	2.9
Q1	5.3
median	8.3
Q3	11.3
95-th percentile	14.6
Maximum	20
Range	18
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.7735638
Coefficient of variation (CV)	0.44624016
Kurtosis	-0.59788646
Mean	8.456352
Median Absolute Deviation (MAD)	3
Skewness	0.30656478
Sum	1179661.1
Variance	14.239784
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.4	1259	0.8%
6	1249	0.8%
5.8	1248	0.8%
9.5	1246	0.8%
6.5	1239	0.8%
6.2	1237	0.8%
5.1	1235	0.8%
7.7	1230	0.8%
6.7	1228	0.8%
8.9	1224	0.8%
Other values (171)	127105	84.7%
(Missing)	10500	7.0%

Value	Count	Frequency (%)
2	411	0.3%
2.1	838	0.6%
2.2	787	0.5%
2.3	791	0.5%
2.4	810	0.5%
2.5	819	0.5%
2.6	812	0.5%
2.7	787	0.5%
2.8	814	0.5%
2.9	824	0.5%

Value	Count	Frequency (%)
20	38	< 0.1%
19.9	84	0.1%
19.8	78	0.1%
19.7	68	< 0.1%
19.6	78	0.1%
19.5	57	< 0.1%
19.4	92	0.1%
19.3	61	< 0.1%
19.2	75	0.1%
19.1	59	< 0.1%

Avg CTAT
Real number (ℝ)

Missing

Distinct	351
Distinct (%)	0.3%
Missing	48000
Missing (%)	32.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.149636

Minimum	10
Maximum	45
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	10
5-th percentile	15.8
Q1	21.6
median	28.8
Q3	36.8
95-th percentile	43.4
Maximum	45
Range	35
Interquartile range (IQR)	15.2

Descriptive statistics

Standard deviation	8.9025772
Coefficient of variation (CV)	0.30540955
Kurtosis	-1.1235657
Mean	29.149636
Median Absolute Deviation (MAD)	7.6
Skewness	0.045899577
Sum	2973262.9
Variance	79.255882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.8	401	0.3%
25.9	389	0.3%
28.1	388	0.3%
20.5	386	0.3%
25.3	383	0.3%
17.2	382	0.3%
23.5	381	0.3%
18.5	380	0.3%
27.7	380	0.3%
20	380	0.3%
Other values (341)	98150	65.4%
(Missing)	48000	32.0%

Value	Count	Frequency (%)
10	23	< 0.1%
10.1	48	< 0.1%
10.2	44	< 0.1%
10.3	43	< 0.1%
10.4	52	< 0.1%
10.5	48	< 0.1%
10.6	47	< 0.1%
10.7	48	< 0.1%
10.8	43	< 0.1%
10.9	43	< 0.1%

Value	Count	Frequency (%)
45	144	0.1%
44.9	318	0.2%
44.8	315	0.2%
44.7	333	0.2%
44.6	306	0.2%
44.5	296	0.2%
44.4	320	0.2%
44.3	259	0.2%
44.2	304	0.2%
44.1	317	0.2%

Cancelled Rides by Customer
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	139500
Missing (%)	93.0%
Memory size	8.0 MiB

1.0	10500

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	31500
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	10500	7.0%
(Missing)	139500	93.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	10500	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	10500	33.3%
.	10500	33.3%
0	10500	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	10500	33.3%
.	10500	33.3%
0	10500	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	10500	33.3%
.	10500	33.3%
0	10500	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	10500	33.3%
.	10500	33.3%
0	10500	33.3%

Reason for cancelling by Customer
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	139500
Missing (%)	93.0%
Memory size	8.2 MiB

Wrong Address	2362
Change of plans	2353
Driver is not moving towards pickup location	2335
Driver asked to cancel	2295
AC is not working	1155

Length

Max length	44
Median length	17
Mean length	22.749143
Min length	13

Characters and Unicode

Total characters	238866
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Driver is not moving towards pickup location
2nd row	Driver is not moving towards pickup location
3rd row	Driver asked to cancel
4th row	Driver is not moving towards pickup location
5th row	Driver asked to cancel

Common Values

Value	Count	Frequency (%)
Wrong Address	2362	1.6%
Change of plans	2353	1.6%
Driver is not moving towards pickup location	2335	1.6%
Driver asked to cancel	2295	1.5%
AC is not working	1155	0.8%
(Missing)	139500	93.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
driver	4630	11.0%
not	3490	8.3%
is	3490	8.3%
wrong	2362	5.6%
address	2362	5.6%
plans	2353	5.6%
of	2353	5.6%
change	2353	5.6%
moving	2335	5.6%
towards	2335	5.6%
Other values (7)	13865	33.1%

Most occurring characters

Value	Count	Frequency (%)
	31428	13.2%
o	20995	8.8%
n	18678	7.8%
r	17474	7.3%
i	16280	6.8%
s	15197	6.4%
a	13966	5.8%
e	13935	5.8%
t	10455	4.4%
d	9354	3.9%
Other values (15)	71104	29.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238866	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	31428	13.2%
o	20995	8.8%
n	18678	7.8%
r	17474	7.3%
i	16280	6.8%
s	15197	6.4%
a	13966	5.8%
e	13935	5.8%
t	10455	4.4%
d	9354	3.9%
Other values (15)	71104	29.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238866	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	31428	13.2%
o	20995	8.8%
n	18678	7.8%
r	17474	7.3%
i	16280	6.8%
s	15197	6.4%
a	13966	5.8%
e	13935	5.8%
t	10455	4.4%
d	9354	3.9%
Other values (15)	71104	29.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238866	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	31428	13.2%
o	20995	8.8%
n	18678	7.8%
r	17474	7.3%
i	16280	6.8%
s	15197	6.4%
a	13966	5.8%
e	13935	5.8%
t	10455	4.4%
d	9354	3.9%
Other values (15)	71104	29.8%

Cancelled Rides by Driver
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	123000
Missing (%)	82.0%
Memory size	7.9 MiB

1.0	27000

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	81000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	27000	18.0%
(Missing)	123000	82.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	27000	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	27000	33.3%
.	27000	33.3%
0	27000	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	81000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	27000	33.3%
.	27000	33.3%
0	27000	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	81000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	27000	33.3%
.	27000	33.3%
0	27000	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	81000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	27000	33.3%
.	27000	33.3%
0	27000	33.3%

Driver Cancellation Reason
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	123000
Missing (%)	82.0%
Memory size	8.6 MiB

Customer related issue	6837
The customer was coughing/sick	6751
Personal & Car related issues	6726
More than permitted people in there	6686

Length

Max length	35
Median length	30
Mean length	28.963259
Min length	22

Characters and Unicode

Total characters	782008
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Personal & Car related issues
2nd row	Customer related issue
3rd row	Customer related issue
4th row	Personal & Car related issues
5th row	More than permitted people in there

Common Values

Value	Count	Frequency (%)
Customer related issue	6837	4.6%
The customer was coughing/sick	6751	4.5%
Personal & Car related issues	6726	4.5%
More than permitted people in there	6686	4.5%
(Missing)	123000	82.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
customer	13588	11.2%
related	13563	11.2%
issue	6837	5.6%
the	6751	5.6%
was	6751	5.6%
coughing/sick	6751	5.6%
personal	6726	5.5%
	6726	5.5%
car	6726	5.5%
issues	6726	5.5%
Other values (6)	40116	33.1%

Most occurring characters

Value	Count	Frequency (%)
e	114556	14.6%
	94261	12.1%
s	67668	8.7%
r	60661	7.8%
t	53895	6.9%
a	40452	5.2%
o	40437	5.2%
i	40437	5.2%
u	33902	4.3%
l	26975	3.4%
Other values (15)	208764	26.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	782008	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	114556	14.6%
	94261	12.1%
s	67668	8.7%
r	60661	7.8%
t	53895	6.9%
a	40452	5.2%
o	40437	5.2%
i	40437	5.2%
u	33902	4.3%
l	26975	3.4%
Other values (15)	208764	26.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	782008	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	114556	14.6%
	94261	12.1%
s	67668	8.7%
r	60661	7.8%
t	53895	6.9%
a	40452	5.2%
o	40437	5.2%
i	40437	5.2%
u	33902	4.3%
l	26975	3.4%
Other values (15)	208764	26.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	782008	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	114556	14.6%
	94261	12.1%
s	67668	8.7%
r	60661	7.8%
t	53895	6.9%
a	40452	5.2%
o	40437	5.2%
i	40437	5.2%
u	33902	4.3%
l	26975	3.4%
Other values (15)	208764	26.7%

Incomplete Rides
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	141000
Missing (%)	94.0%
Memory size	8.0 MiB

1.0	9000

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	27000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	9000	6.0%
(Missing)	141000	94.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	9000	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	9000	33.3%
.	9000	33.3%
0	9000	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	27000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	9000	33.3%
.	9000	33.3%
0	9000	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	27000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	9000	33.3%
.	9000	33.3%
0	9000	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	27000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	9000	33.3%
.	9000	33.3%
0	9000	33.3%

Incomplete Rides Reason
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	141000
Missing (%)	94.0%
Memory size	8.1 MiB

Customer Demand	3040
Vehicle Breakdown	3012
Other Issue	2948

Length

Max length	17
Median length	15
Mean length	14.359111
Min length	11

Characters and Unicode

Total characters	129232
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Vehicle Breakdown
2nd row	Other Issue
3rd row	Vehicle Breakdown
4th row	Other Issue
5th row	Vehicle Breakdown

Common Values

Value	Count	Frequency (%)
Customer Demand	3040	2.0%
Vehicle Breakdown	3012	2.0%
Other Issue	2948	2.0%
(Missing)	141000	94.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
customer	3040	16.9%
demand	3040	16.9%
vehicle	3012	16.7%
breakdown	3012	16.7%
other	2948	16.4%
issue	2948	16.4%

Most occurring characters

Value	Count	Frequency (%)
e	21012	16.3%
	9000	7.0%
r	9000	7.0%
s	8936	6.9%
m	6080	4.7%
o	6052	4.7%
a	6052	4.7%
d	6052	4.7%
n	6052	4.7%
u	5988	4.6%
Other values (13)	45008	34.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	129232	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	21012	16.3%
	9000	7.0%
r	9000	7.0%
s	8936	6.9%
m	6080	4.7%
o	6052	4.7%
a	6052	4.7%
d	6052	4.7%
n	6052	4.7%
u	5988	4.6%
Other values (13)	45008	34.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	129232	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	21012	16.3%
	9000	7.0%
r	9000	7.0%
s	8936	6.9%
m	6080	4.7%
o	6052	4.7%
a	6052	4.7%
d	6052	4.7%
n	6052	4.7%
u	5988	4.6%
Other values (13)	45008	34.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	129232	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	21012	16.3%
	9000	7.0%
r	9000	7.0%
s	8936	6.9%
m	6080	4.7%
o	6052	4.7%
a	6052	4.7%
d	6052	4.7%
n	6052	4.7%
u	5988	4.6%
Other values (13)	45008	34.8%

Booking Value
Real number (ℝ)

Missing

Distinct	2566
Distinct (%)	2.5%
Missing	48000
Missing (%)	32.0%
Infinite	0
Infinite (%)	0.0%
Mean	508.29591

Minimum	50
Maximum	4277
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	50
5-th percentile	91
Q1	234
median	414
Q3	689
95-th percentile	1224
Maximum	4277
Range	4227
Interquartile range (IQR)	455

Descriptive statistics

Standard deviation	395.80577
Coefficient of variation (CV)	0.77869163
Kurtosis	9.8878804
Mean	508.29591
Median Absolute Deviation (MAD)	211
Skewness	2.287351
Sum	51846183
Variance	156662.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
176	177	0.1%
125	174	0.1%
200	170	0.1%
408	169	0.1%
186	168	0.1%
353	167	0.1%
357	166	0.1%
157	166	0.1%
470	166	0.1%
206	165	0.1%
Other values (2556)	100312	66.9%
(Missing)	48000	32.0%

Value	Count	Frequency (%)
50	121	0.1%
51	108	0.1%
52	116	0.1%
53	137	0.1%
54	96	0.1%
55	105	0.1%
56	115	0.1%
57	113	0.1%
58	109	0.1%
59	116	0.1%

Value	Count	Frequency (%)
4277	1	< 0.1%
4228	1	< 0.1%
4220	1	< 0.1%
4202	1	< 0.1%
4133	1	< 0.1%
4109	1	< 0.1%
4093	1	< 0.1%
4088	1	< 0.1%
4060	1	< 0.1%
4044	1	< 0.1%

Ride Distance
Real number (ℝ)

Missing

Distinct	4901
Distinct (%)	4.8%
Missing	48000
Missing (%)	32.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.637012

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	3.97
Q1	12.46
median	23.72
Q3	36.82
95-th percentile	47.35
Maximum	50
Range	49
Interquartile range (IQR)	24.36

Descriptive statistics

Standard deviation	14.002138
Coefficient of variation (CV)	0.56833753
Kurtosis	-1.2122664
Mean	24.637012
Median Absolute Deviation (MAD)	12.1
Skewness	0.12831234
Sum	2512975.2
Variance	196.05988
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.31	43	< 0.1%
9.61	43	< 0.1%
14.47	42	< 0.1%
3.44	41	< 0.1%
12.87	41	< 0.1%
12.52	40	< 0.1%
12.67	39	< 0.1%
8.69	39	< 0.1%
8.97	39	< 0.1%
14.93	38	< 0.1%
Other values (4891)	101595	67.7%
(Missing)	48000	32.0%

Value	Count	Frequency (%)
1	6	< 0.1%
1.01	3	< 0.1%
1.02	3	< 0.1%
1.03	5	< 0.1%
1.04	3	< 0.1%
1.05	3	< 0.1%
1.06	4	< 0.1%
1.07	6	< 0.1%
1.08	1	< 0.1%
1.09	5	< 0.1%

Value	Count	Frequency (%)
50	9	< 0.1%
49.99	19	< 0.1%
49.98	20	< 0.1%
49.97	22	< 0.1%
49.96	18	< 0.1%
49.95	17	< 0.1%
49.94	21	< 0.1%
49.93	24	< 0.1%
49.92	16	< 0.1%
49.91	18	< 0.1%

Driver Ratings
Real number (ℝ)

High correlation Missing

Distinct	21
Distinct (%)	< 0.1%
Missing	57000
Missing (%)	38.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2309925

Minimum	3
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	3
5-th percentile	3.3
Q1	4.1
median	4.3
Q3	4.6
95-th percentile	4.9
Maximum	5
Range	2
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.43687147
Coefficient of variation (CV)	0.10325508
Kurtosis	0.2802387
Mean	4.2309925
Median Absolute Deviation (MAD)	0.2
Skewness	-0.65571516
Sum	393482.3
Variance	0.19085668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4.3	14081	9.4%
4.2	13841	9.2%
4.6	9368	6.2%
4.4	7018	4.7%
4.1	6966	4.6%
4.9	4705	3.1%
4.7	4678	3.1%
4.5	4634	3.1%
3.9	3915	2.6%
3.8	3848	2.6%
Other values (11)	19946	13.3%
(Missing)	57000	38.0%

Value	Count	Frequency (%)
3	745	0.5%
3.1	1459	1.0%
3.2	1538	1.0%
3.3	1461	1.0%
3.4	1491	1.0%
3.5	748	0.5%
3.6	2026	1.4%
3.7	3790	2.5%
3.8	3848	2.6%
3.9	3915	2.6%

Value	Count	Frequency (%)
5	2365	1.6%
4.9	4705	3.1%
4.8	2328	1.6%
4.7	4678	3.1%
4.6	9368	6.2%
4.5	4634	3.1%
4.4	7018	4.7%
4.3	14081	9.4%
4.2	13841	9.2%
4.1	6966	4.6%

Customer Rating
Real number (ℝ)

High correlation Missing

Distinct	21
Distinct (%)	< 0.1%
Missing	57000
Missing (%)	38.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4045839

Minimum	3
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	3
5-th percentile	3.6
Q1	4.2
median	4.5
Q3	4.8
95-th percentile	5
Maximum	5
Range	2
Interquartile range (IQR)	0.6

Descriptive statistics

Standard deviation	0.43781873
Coefficient of variation (CV)	0.099400703
Kurtosis	0.64796636
Mean	4.4045839
Median Absolute Deviation (MAD)	0.3
Skewness	-0.88553068
Sum	409626.3
Variance	0.19168524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4.9	11642	7.8%
4.6	11533	7.7%
4.3	10995	7.3%
4.2	10697	7.1%
4.5	5890	3.9%
4.8	5880	3.9%
5	5837	3.9%
4.7	5763	3.8%
4.1	5396	3.6%
4.4	5279	3.5%
Other values (11)	14088	9.4%
(Missing)	57000	38.0%

Value	Count	Frequency (%)
3	468	0.3%
3.1	1008	0.7%
3.2	881	0.6%
3.3	900	0.6%
3.4	928	0.6%
3.5	443	0.3%
3.6	1194	0.8%
3.7	2354	1.6%
3.8	2357	1.6%
3.9	2370	1.6%

Value	Count	Frequency (%)
5	5837	3.9%
4.9	11642	7.8%
4.8	5880	3.9%
4.7	5763	3.8%
4.6	11533	7.7%
4.5	5890	3.9%
4.4	5279	3.5%
4.3	10995	7.3%
4.2	10697	7.1%
4.1	5396	3.6%

Payment Method
Categorical

Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	48000
Missing (%)	32.0%
Memory size	7.9 MiB

UPI	45909
Cash	25367
Uber Wallet	12276
Credit Card	10209
Debit Card	8239

Length

Max length	11
Median length	10
Mean length	5.5776471
Min length	3

Characters and Unicode

Total characters	568920
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UPI
2nd row	Debit Card
3rd row	UPI
4th row	UPI
5th row	UPI

Common Values

Value	Count	Frequency (%)
UPI	45909	30.6%
Cash	25367	16.9%
Uber Wallet	12276	8.2%
Credit Card	10209	6.8%
Debit Card	8239	5.5%
(Missing)	48000	32.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
upi	45909	34.6%
cash	25367	19.1%
card	18448	13.9%
uber	12276	9.2%
wallet	12276	9.2%
credit	10209	7.7%
debit	8239	6.2%

Most occurring characters

Value	Count	Frequency (%)
U	58185	10.2%
a	56091	9.9%
C	54024	9.5%
I	45909	8.1%
P	45909	8.1%
e	43000	7.6%
r	40933	7.2%
	30724	5.4%
t	30724	5.4%
d	28657	5.0%
Other values (7)	134764	23.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	568920	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	58185	10.2%
a	56091	9.9%
C	54024	9.5%
I	45909	8.1%
P	45909	8.1%
e	43000	7.6%
r	40933	7.2%
	30724	5.4%
t	30724	5.4%
d	28657	5.0%
Other values (7)	134764	23.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	568920	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	58185	10.2%
a	56091	9.9%
C	54024	9.5%
I	45909	8.1%
P	45909	8.1%
e	43000	7.6%
r	40933	7.2%
	30724	5.4%
t	30724	5.4%
d	28657	5.0%
Other values (7)	134764	23.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	568920	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	58185	10.2%
a	56091	9.9%
C	54024	9.5%
I	45909	8.1%
P	45909	8.1%
e	43000	7.6%
r	40933	7.2%
	30724	5.4%
t	30724	5.4%
d	28657	5.0%
Other values (7)	134764	23.7%

Interactions

Correlations

	Avg CTAT	Avg VTAT	Booking Status	Booking Value	Customer Rating	Driver Cancellation Reason	Driver Ratings	Incomplete Rides Reason	Payment Method	Reason for cancelling by Customer	Ride Distance	Vehicle Type
Avg CTAT	1.000	0.059	0.471	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.099	0.000
Avg VTAT	0.059	1.000	0.338	0.005	-0.003	0.000	-0.005	0.000	0.000	0.012	0.063	0.000
Booking Status	0.471	0.338	1.000	0.002	1.000	1.000	1.000	1.000	0.000	1.000	0.353	0.002
Booking Value	0.001	0.005	0.002	1.000	-0.004	0.000	0.001	0.000	0.000	0.000	0.004	0.000
Customer Rating	0.000	-0.003	1.000	-0.004	1.000	0.000	-0.002	0.000	0.000	0.000	0.005	0.005
Driver Cancellation Reason	0.000	0.000	1.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000
Driver Ratings	0.000	-0.005	1.000	0.001	-0.002	0.000	1.000	0.000	0.000	0.000	-0.001	0.000
Incomplete Rides Reason	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.013	0.016
Payment Method	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.005	0.006
Reason for cancelling by Customer	0.000	0.012	1.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.168
Ride Distance	0.099	0.063	0.353	0.004	0.005	0.000	-0.001	0.013	0.005	0.000	1.000	0.000
Vehicle Type	0.000	0.000	0.002	0.000	0.005	0.000	0.000	0.016	0.006	0.168	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Date	Time	Booking ID	Booking Status	Customer ID	Vehicle Type	Pickup Location	Drop Location	Avg VTAT	Avg CTAT	Cancelled Rides by Customer	Reason for cancelling by Customer	Cancelled Rides by Driver	Driver Cancellation Reason	Incomplete Rides	Incomplete Rides Reason	Booking Value	Ride Distance	Driver Ratings	Customer Rating	Payment Method
0	2024-03-23	12:29:38	"CNR5884300"	No Driver Found	"CID1982111"	eBike	Palam Vihar	Jhilmil	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	2024-11-29	18:01:39	"CNR1326809"	Incomplete	"CID4604802"	Go Sedan	Shastri Nagar	Gurgaon Sector 56	4.9	14.0	NaN	NaN	NaN	NaN	1.0	Vehicle Breakdown	237.0	5.73	NaN	NaN	UPI
2	2024-08-23	08:56:10	"CNR8494506"	Completed	"CID9202816"	Auto	Khandsa	Malviya Nagar	13.4	25.8	NaN	NaN	NaN	NaN	NaN	NaN	627.0	13.58	4.9	4.9	Debit Card
3	2024-10-21	17:17:25	"CNR8906825"	Completed	"CID2610914"	Premier Sedan	Central Secretariat	Inderlok	13.1	28.5	NaN	NaN	NaN	NaN	NaN	NaN	416.0	34.02	4.6	5.0	UPI
4	2024-09-16	22:08:00	"CNR1950162"	Completed	"CID9933542"	Bike	Ghitorni Village	Khan Market	5.3	19.6	NaN	NaN	NaN	NaN	NaN	NaN	737.0	48.21	4.1	4.3	UPI
5	2024-02-06	09:44:56	"CNR4096693"	Completed	"CID4670564"	Auto	AIIMS	Narsinghpur	5.1	18.1	NaN	NaN	NaN	NaN	NaN	NaN	316.0	4.85	4.1	4.6	UPI
6	2024-06-17	15:45:58	"CNR2002539"	Completed	"CID6800553"	Go Mini	Vaishali	Punjabi Bagh	7.1	20.4	NaN	NaN	NaN	NaN	NaN	NaN	640.0	41.24	4.0	4.1	UPI
7	2024-03-19	17:37:37	"CNR6568000"	Completed	"CID8610436"	Auto	Mayur Vihar	Cyber Hub	12.1	16.5	NaN	NaN	NaN	NaN	NaN	NaN	136.0	6.56	4.4	4.2	UPI
8	2024-09-14	12:49:09	"CNR4510807"	No Driver Found	"CID7873618"	Go Sedan	Noida Sector 62	Noida Sector 18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	2024-12-16	19:06:48	"CNR7721892"	Incomplete	"CID5214275"	Auto	Rohini	Adarsh Nagar	6.1	26.0	NaN	NaN	NaN	NaN	1.0	Other Issue	135.0	10.36	NaN	NaN	Cash

	Date	Time	Booking ID	Booking Status	Customer ID	Vehicle Type	Pickup Location	Drop Location	Avg VTAT	Avg CTAT	Cancelled Rides by Customer	Reason for cancelling by Customer	Cancelled Rides by Driver	Driver Cancellation Reason	Incomplete Rides	Incomplete Rides Reason	Booking Value	Ride Distance	Driver Ratings	Customer Rating	Payment Method
149990	2024-09-26	12:31:22	"CNR3212810"	Cancelled by Driver	"CID6199171"	Auto	Kashmere Gate ISBT	GTB Nagar	10.7	NaN	NaN	NaN	1.0	Personal & Car related issues	NaN	NaN	NaN	NaN	NaN	NaN	NaN
149991	2024-07-13	14:47:30	"CNR5591053"	Completed	"CID1829616"	Auto	Karol Bagh	Vishwavidyalaya	11.2	30.8	NaN	NaN	NaN	NaN	NaN	NaN	597.0	27.91	4.2	4.3	UPI
149992	2024-01-24	18:02:28	"CNR1717894"	No Driver Found	"CID9564749"	Go Mini	Nehru Place	Aya Nagar	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
149993	2024-05-03	11:18:17	"CNR9715958"	Completed	"CID8835432"	Go Mini	Tughlakabad	Jama Masjid	13.2	20.1	NaN	NaN	NaN	NaN	NaN	NaN	280.0	29.89	4.1	4.7	Cash
149994	2024-06-14	16:46:53	"CNR9572383"	Completed	"CID2952237"	Go Mini	Akshardham	Greater Noida	8.2	30.6	NaN	NaN	NaN	NaN	NaN	NaN	388.0	10.51	4.3	4.9	UPI
149995	2024-11-11	19:34:01	"CNR6500631"	Completed	"CID4337371"	Go Mini	MG Road	Ghitorni	10.2	44.4	NaN	NaN	NaN	NaN	NaN	NaN	475.0	40.08	3.7	4.1	Uber Wallet
149996	2024-11-24	15:55:09	"CNR2468611"	Completed	"CID2325623"	Go Mini	Golf Course Road	Akshardham	5.1	30.8	NaN	NaN	NaN	NaN	NaN	NaN	1093.0	21.31	4.8	5.0	UPI
149997	2024-09-18	10:55:15	"CNR6358306"	Completed	"CID9925486"	Go Sedan	Satguru Ram Singh Marg	Jor Bagh	2.7	23.4	NaN	NaN	NaN	NaN	NaN	NaN	852.0	15.93	3.9	4.4	Cash
149998	2024-10-05	07:53:34	"CNR3030099"	Completed	"CID9415487"	Auto	Ghaziabad	Saidulajab	6.9	39.6	NaN	NaN	NaN	NaN	NaN	NaN	333.0	45.54	4.1	3.7	UPI
149999	2024-03-10	15:38:03	"CNR3447390"	Completed	"CID4108667"	Premier Sedan	Ashok Park Main	Gurgaon Sector 29	3.5	33.7	NaN	NaN	NaN	NaN	NaN	NaN	806.0	21.19	4.6	4.9	Credit Card

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block